<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Filtering metrics on rank and percentage ranges</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
table.whs1 { x-cell-content-align:top; border-spacing:0px; }
tr.whs2 { x-cell-content-align:top; }
td.whs3 { padding-right:10px; padding-left:10px; border-left-style:Solid; border-left-color:#000000; border-top-color:#000000; border-top-style:Solid; border-right-style:Solid; border-right-color:#000000; border-bottom-color:#000000; border-bottom-style:Solid; border-right-width:1px; border-left-width:1px; border-top-width:1px; border-bottom-width:1px; background-color:#e7e7e7; }
p.whs4 { font-weight:bold; }
td.whs5 { padding-right:10px; padding-left:10px; border-top-color:#000000; border-top-style:Solid; border-right-style:Solid; border-right-color:#000000; border-bottom-color:#000000; border-bottom-style:Solid; border-top-width:1px; border-bottom-width:1px; border-right-width:1px; background-color:#e7e7e7; }
td.whs6 { padding-right:10px; padding-left:10px; border-left-style:Solid; border-left-color:#000000; border-left-width:1px; border-right-style:Solid; border-right-color:#000000; border-right-width:1px; border-bottom-width:1px; border-bottom-color:#000000; border-bottom-style:Solid; }
td.whs7 { padding-right:10px; padding-left:10px; border-right-style:Solid; border-right-color:#000000; border-right-width:1px; border-bottom-width:1px; border-bottom-color:#000000; border-bottom-style:Solid; }
td.whs8 { border-left-width:1px; border-left-color:#000000; border-left-style:Solid; border-right-width:1px; border-right-color:#000000; border-right-style:Solid; border-bottom-style:Solid; border-bottom-color:#000000; border-bottom-width:1px; padding-right:10px; padding-left:10px; }
td.whs9 { border-right-width:1px; border-right-color:#000000; border-right-style:Solid; border-bottom-style:Solid; border-bottom-color:#000000; border-bottom-width:1px; padding-right:10px; padding-left:10px; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Analyzing report and document results\nRestricting report results: Filtering\nFiltering metrics on rank and percentage ranges");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Filtering metrics on rank and percentage ranges</h1>
<p>In addition to restricting report results based on qualifications of 
 metrics, you can also restrict report results based on the rank or percentage 
 range of a metric value for a given report. This enables you to display 
 reports with data such as products in the top 40% of profit. You could 
 also create a report to return the top 10 employees in terms of average 
 performance score. </p>
<p>It is important to understand the operators that are available for these 
 types of view filters. When creating view filter qualifications on the 
 rank or percentage ranges of metric values, you can use the following 
 mathematical and logical operators, which are described as they relate 
 to rank and percent metric qualifications in the table below:</p>
<table x-use-null-cells cellspacing="0" class="whs1">
<script language='JavaScript'><!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4)) document.write("</table><table x-use-null-cells cellspacing='0' border='1' bordercolor='black' bordercolorlight='black' bordercolordark='black'>");
//--></script>
<col>
<col>


<tr valign="top" class="whs2">
<td bgcolor="#E7E7E7" class="whs3">
<p class="whs4">Operator</td>
<td bgcolor="#E7E7E7" class="whs5">
<p class="whs4">Functionality and considerations</td></tr>

<tr valign="top" class="whs2">
<td class="whs6">
<p>Exactly</td>
<td class="whs7">
<p>Identifies a specific value, as described below:</p>
<ul>
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>For rank 
 ranges, this restricts a report to data for only one specific rank. For 
 example, a rank range defined as Exactly 1 returns data for only the highest 
 value of a given metric. This scenario produces the same results as using 
 the Is Highest operator described below in this table. </p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>For percent 
 ranges, this operator has limited value. This is because it restricts 
 a report to data for only data that is exactly a specific percentage. 
 Percentages are not always integer values and therefore it is difficult 
 to predict what percentage would return meaningful results. </p></li>
</ul></td></tr>

<tr valign="top" class="whs2">
<td class="whs8">
<p>Different from</td>
<td class="whs9">
<p>Identifies values that are other than the specific value indicated:</p>
<ul>
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>For rank 
 metric qualifications, this restricts a report to data for only ranks 
 that are different from the given value. For example, a rank range defined 
 as different from 1 returns data for all ranks except the highest value 
 of a given metric. </p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>For percent 
 ranges, this operator has limited value. This is because it restricts 
 a report to data that is different from a specific percentage. Percentages 
 are not always integer values and therefore it is difficult to predict 
 what percentage would return meaningful results. In most cases, using 
 this operator with percent metric qualifications does not restrict any 
 data. </p></li>
</ul></td></tr>

<tr valign="top" class="whs2">
<td class="whs8">
<p>Between</td>
<td class="whs9">
<p>Identifies values in a range that has both a lower and an upper limit:</p>
<ul>
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>For rank 
 ranges, you can provide a lower and upper rank limit. For example, you 
 can display only ranks 20 through 40. </p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>For percent 
 ranges, you can provide a lower and upper percentage limit. For example, 
 you can display only data with metric values between 20% and 40% of all 
 values.</p></li>
</ul></td></tr>

<tr valign="top" class="whs2">
<td class="whs8">
<p>Not Between</td>
<td class="whs9">
<p>Identifies values in a range that has both a lower and an upper limit. 
 Data is restricted for any values outside of this range:</p>
<ul>
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>For rank 
 ranges, you can provide a lower and upper rank limit. For example, you 
 can display only ranks not between 20 through 40. This displays ranks 
 1 through 19 and 41 and down. </p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>For percent 
 ranges, you can provide a lower and upper percentage limit. For example, 
 you can display only data with metric values not between 20% and 40% of 
 all values. This displays data with metric values between 1% and 19% and 
 between 41% and 100%. </p></li>
</ul></td></tr>

<tr valign="top" class="whs2">
<td class="whs8">
<p>Is Null</td>
<td class="whs9">
<p>Identifies values that are null. &nbsp;Using the rank 
 or percent metric qualifications is not necessary with this operator. 
 To return all data where metric values are Null, you can simply create 
 a view filter metric qualification on the metric that uses the Is Null 
 function.</td></tr>

<tr valign="top" class="whs2">
<td class="whs8">
<p>Is Not Null</td>
<td class="whs9">
<p>Identifies values that are not null. Using the rank or percent metric 
 qualifications is not necessary with this operator. To return all data 
 where metric values are not null, you can simply create a view filter 
 metric qualification on the metric that uses the Is Not Null function. 
 </td></tr>

<tr valign="top" class="whs2">
<td class="whs8">
<p>Top</td>
<td class="whs9">
<p>Identifies the topmost value range in a given set:</p>
<ul>
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>For rank 
 ranges, you can provide a topmost rank range. For example, you can display 
 only data within the top 20 rank range.</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>For percentage 
 ranges, you can provide a topmost percentage range. For example, you can 
 display only data within the top 20% range.</p></li>
</ul></td></tr>

<tr valign="top" class="whs2">
<td class="whs8">
<p>Bottom</td>
<td class="whs9">
<p>Identifies the lowest set of values in a given set:</p>
<ul>
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>For rank 
 ranges, you can provide a lowest rank range. For example, you can display 
 only data within the bottom 20 rank range.</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>For percentage 
 ranges, you can provide a lowest percentage range. For example, you can 
 display only data within the bottom 20% range.</p></li>
</ul></td></tr>

<tr valign="top" class="whs2">
<td class="whs8">
<p>Exclude top</td>
<td class="whs9">
<p>Identifies a value range that is not in the topmost value range in a 
 given set:</p>
<ul>
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>For rank 
 ranges, you can provide a topmost rank range to exclude from the report 
 results. For example, you can display only data that excludes the top 
 20 rank range.</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>For percentage 
 ranges, you can provide a topmost percentage range to exclude from the 
 report results. For example, you can display only data that excludes the 
 top 20% range.</p></li>
</ul></td></tr>

<tr valign="top" class="whs2">
<td class="whs8">
<p>Exclude bottom</td>
<td class="whs9">
<p>Identifies a value range that is not in the lowest set of values in 
 a given set:</p>
<ul>
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>For rank 
 ranges, you can provide a lowest rank range to exclude from the report 
 results. For example, you can display only data that excludes the bottom 
 20 rank range.</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>For percentage 
 ranges, you can provide a lowest percentage range to exclude from the 
 report results. For example, you can display only data that excludes the 
 bottom 20% range.</p></li>
</ul></td></tr>

<tr valign="top" class="whs2">
<td class="whs8">
<p>Is Highest </td>
<td class="whs9">
<p>Identifies the highest value. This operator should only be used with 
 rank ranges. For rank ranges, this restricts report results to display 
 data for only the highest value of a given metric. </td></tr>

<tr valign="top" class="whs2">
<td class="whs8">
<p>Is Lowest</td>
<td class="whs9">
<p>Identifies the lowest value. This operator should only be used with 
 rank ranges. For rank ranges, this restricts report results to display 
 data for only the lowest value of a given metric. </td></tr>
<script language='JavaScript'><!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4)) document.write("</table></table><table>");
//--></script>
</table>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
